﻿CREATE TRIGGER CommitteeBankAccountMainBranchDepositAttachments_Tracking_Delete
ON [dbo].[CommitteeBankAccountMainBranchDepositAttachments] 
AFTER delete
AS 
BEGIN
	UPDATE Sync.CommitteeBankAccountMainBranchDepositAttachments_Tracking 
	SET LastUpdatedDate  = getdate(),
		IsDeleted = 1
	FROM Sync.CommitteeBankAccountMainBranchDepositAttachments_Tracking s JOIN DELETED i
    ON s.CommitteeBankAccountMainBranchDepositAttachmentID = i.CommitteeBankAccountMainBranchDepositAttachmentID
END











